WilmerHale is a leading, full-service international law firm with 1,000 lawyers located throughout 13 offices in the United States, Europe and Asia. Our lawyers work at the intersection of government, technology and business, and we remain committed to our guiding principles of providing quality, excellent legal and client services; developing diversity among our lawyers and staff and cultivating an environment that promotes an ambitious spirit, collaboration and collegiality by drawing on the extraordinary talents and dynamic experience of our lawyers. Our goal is to reflect the diversity of our clients and the communities in which we practice.

What You Will Be Doing

Responsible for the design, implementation, and maintenance of all SQL Analysis Services tabular cube within the Firm.Serve as an advisor to PowerBI report developers, providing guidance on dimensional modeling and tabular design best practices.

About The Role

• Responsible to ensure alignment between the data analytics platforms (Data warehouse) environment and business requirements
• Extends existing and creates new MS SQL Analysis Services Tabular Cubes using new members, measures using DAX scripting languages, tables, relationships, and roles
• Extends existing and creates new PowerBI models using new members, measures, tables, relationships, and roles, in direct query and import models
• Creates and delivers end-user training and documentation and provides second-line support to power users who develop reports on behalf of their departmental colleagues
• Performs application deployments, upgrades, and patch planning
• Participate and contribute to daily scrum meetings
• Maintains awareness of technology developments and makes recommendations to the Manager, Data Analytics Services
• Participates in software licensing and support agreement discussions
• Assists with resolution of escalated incidents and participates in problem management activities.Assumes ownership of level 3 support and troubleshooting of assigned data solutions
• Assists in evaluating the business relevance and requirements of projects under consideration
• Maintain existing data solutions, design and build from the ground up new data solutions including data warehousing dimensional models
• Mentor junior developers
• Assumes additional responsibilities as assigned
• Contributes to the firm's Service Excellence initiative to consistently improve its image internally and externally.Displays professionalism, quality service and a "can do" attitude to internal members/departments of the firm as well as external clients and vendors via electronic and print correspondence, over the telephone and in-person.